/**
 * DBConstants.java
 * 
 * Copyright@2015 OVT Inc. All rights reserved. 
 * 
 * May 5, 2015
 */
package com.ovt.doorbell.payment.dao.constant;


/**
 * DBConstants
 * 
 * @Author zhi.liu
 * @Version 1.0
 * @See
 * @Since [OVT Cloud Platform]/[API] 1.0
 */
public class DBConstants
{

    public static final class TABLES
    {

        public static class BASE_ENTITY
        {
            public static final String ID = "id";
            public static final String CREATE_TIME = "create_time";
            public static final String UPDATE_TIME = "update_time";
            public static final String UPDATE_BY = "update_by";
        }
        
        public static final class USER extends BASE_ENTITY
        {
            public static final String U_NAME = "admin_name";
            public static final String U_PASSWORD = "admin_pwd";
        }

        public static final class USER_TOKEN extends BASE_ENTITY
        {
            public static final String U_ID = "admin_id";
            public static final String UAT_TOKEN = "at_admin_token ";
            public static final String UAT_EXPIRE_TIME = "at_expire_time";
        }
        
        public static final class PERMISSION extends BASE_ENTITY
        {
            public static final String PERM_NAME = "perm_name";
            public static final String PERM_DESC = "perm_desc";
        }
        
        public static final class USER_PERMISSION extends BASE_ENTITY
        {
            public static final String USER_ID = "admin_id";
            public static final String PERM_ID = "perm_id";
        }
        
        public static final class RESOURCE extends BASE_ENTITY
        {
            public static final String RES_CODE = "res_code";
            public static final String RES_NAME = "res_name";
            public static final String RES_TYPE = "res_type";
            public static final String RES_PRICE = "res_price";
            public static final String RES_UNIT = "res_unit";
            public static final String RES_SIZE = "res_size";
        }
        
        public static final class MEMBER_RESOURCE extends BASE_ENTITY
        {
            public static final String U_ID = "u_id";
            public static final String RES_TYPE = "res_type";
            public static final String RES_SIZE = "res_size";
            public static final String START_TIME = "mr_start_time";
            public static final String EXPIRE_TIME = "mr_expire_time ";
            public static final String END_TIME = "mr_end_time";
            public static final String STATUS = "mr_status";
            public static final String ORDER_NO = "order_no";
        }

        public static final class MEMBERACTION extends BASE_ENTITY
        {
            public static final String USER_ID = "user_id";
            public static final String ACTION_TYPE = "action_type";
            public static final String ACTION_REFERENCE = "action_reference";
        }
    }
        
}
